From a628fddfd683a8e55c846128f08ae68fb6d1e668 Mon Sep 17 00:00:00 2001
From: Stevan Earl <stevan.earl@asu.edu>
Date: Wed, 16 Sep 2026 14:17:37 -0700
Subject: [PATCH] feat(matings): preserve mating descriptions

---
 db/schemas/sokwedb/tables/create/matings.m4 |  2 ++
 doc/src/epilog.inc.m4                       |  2 ++
 doc/src/tables/matings.m4                   | 15 +++++++++++++++
 3 files changed, 19 insertions(+)

diff --git a/db/schemas/sokwedb/tables/create/matings.m4 b/db/schemas/sokwedb/tables/create/matings.m4
index 0f23fd5..aaf3eb5 100644
--- a/db/schemas/sokwedb/tables/create/matings.m4
+++ b/db/schemas/sokwedb/tables/create/matings.m4
@@ -42,6 +42,8 @@ CREATE TABLE matings (
               REFERENCES people
   ,source TEXT NOT NULL
      REFERENCES mating_sources
+  ,description TEXT NOT NULL
+     notonlyspaces_check(`Description')
 );
 
 eid_primary_key(`MATINGS')
diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4
index bf99ea2..dd4c848 100644
--- a/doc/src/epilog.inc.m4
+++ b/doc/src/epilog.inc.m4
@@ -645,6 +645,8 @@ elo_ranks_daily_rst(sdb_male, MT)dnl
    :ref:`ExtractedBy <MATINGS.ExtractedBy>`
 .. |MATINGS.Source| replace::
    :ref:`Source <MATINGS.Source>`
+.. |MATINGS.Description| replace::
+   :ref:`Description <MATINGS.Description>`
 
 .. |NON_BREC_SIGHTING_SOURCES| replace::
    :ref:`NON_BREC_SIGHTING_SOURCES <NON_BREC_SIGHTING_SOURCES>`
diff --git a/doc/src/tables/matings.m4 b/doc/src/tables/matings.m4
index e50dc74..725ec2b 100644
--- a/doc/src/tables/matings.m4
+++ b/doc/src/tables/matings.m4
@@ -73,6 +73,7 @@ The |DYADS| view is useful when querying MATINGS.
         , matings.commid AS matingscommid
         , matings.extractedby
         , matings.source
+            , matings.description
         , dyads.notes
         , dyads.event_notes
      FROM dyads
@@ -278,3 +279,17 @@ Source
 
 |MATINGS.Source_summary|
 |notnull|
+
+
+.. _MATINGS.Description:
+
+Description
+```````````
+
+.. |MATINGS.Description_summary| replace::
+   Description of the mating event, usually copied directly from the
+   source record.
+
+|MATINGS.Description_summary|
+|notonlyspaces|
+|notnull|
-- 
2.34.1